package com.xjrsoft.module.customerTwo.EMP.electricity_cost_records_month.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.xjrsoft.module.customerTwo.EMP.electricity_cost_records_month.dto.TElectricityCostRecordsMonthListDto;
import com.xjrsoft.module.customerTwo.EMP.electricity_cost_records_month.entity.TElectricityCostRecordsMonth;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 *  Mapper 接口
 *
 * @author dongxinhang
 * @since 2023-07-24
 */
public interface TElectricityCostRecordsMonthMapper extends BaseMapper<TElectricityCostRecordsMonth> {


    /**
     * 根据日电量记录汇总月电量记录
     * @param start 日期范围始 yyyy-MM-dd
     * @param end 日期范围止 yyyy-MM-dd
     * @return
     */
    int insertDataByDay(@Param("start")String start, @Param("end")String end);

    List<Map<String,Object>> exportExcel(@Param("dto") TElectricityCostRecordsMonthListDto dto);

    IPage<Map<String,Object>> queryPage(Page page, @Param("dto") TElectricityCostRecordsMonthListDto dto);
}
